Modular Synchronization in Distributed, Multiversion Databases: Version Control and Concurrency Control

نویسندگان

  • Divyakant Agrawal
  • Soumitra Sengupta
چکیده

A version control mechanism is proposed that enhances the modularity and extensibility of multiversion concurrency control algorithms. We decouple the multiversion algorithms into two components: version control and concurrency control. This permits modular development of multiversion protocols, and simplifies the task of proving the correctness of these protocols. A set of procedures for version control is described that defines the interface to the version control component. We show that the same interface can be used by the database actions of both two-phase locking and time-stamp concurrency control protocols to access multiversion data. An interesting feature of our framework is that the execution of read-only transactions becomes completely independent of the underlying concurrency control implementation. Unlike other multiversion algorithms, read-only transactions in this scheme do not modify any version related information, and therefore, do not interfere with the execution of read-write transactions. Finally, the extension of the multiversion algorithms to a distributed environment becomes very simple.

برای دانلود رایگان متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

Implementation of a Virtual Time Synchronizer for Distributed Databases

The availability of high speed networks and improved microprocessor performance have made it possible to build inexpensive cluster of workstations as an appealing platform for parallel and distributed computing. In this paper, we study the performance of a distributed database system synchronized by virtual time (VT) mechanism by experimenting on a LAN-connected collection of 12 SunSPARCS works...

متن کامل

Performance of Multiversion and Distributed Two-Phase Locking Concurrency Control Mechanisms in Distributed Databases

Abstract In this paper we have presented a detailed simulation study of a distributed multiversion and a distributed two-phase locking concurrency control mechanisms. Our experiment concentrated on measuring the effect of message overhead, read:write ratios, data partitioning and partial replication on the performance of these mechanisms. The effect of these parameters has not been investigated...

متن کامل

Apparent Versioning and Concurrency Control in Object-Oriented Databases

The problem of consistency of object-oriented databases is considered, when objects contained in the database are multiversion, and they are accessed by concurrent transactions. In such databases there are two aspects of the consistency problem, one related to concurrency, as in monoversion databases, and the other related to versioning. In this paper the problems of mutual dependencies of vers...

متن کامل

Analysis of Real-Time Multi version Concurrency Control Algorithms using Serialisability Graphs

57 ABSTRACT This paper analyses the correctness of Multiversion Concurrency Control(MVCC) algorithms that are commonly deployed in Realtime Databases. Database systems for real-time applications must satisfy timing constraints associated with transactions. Typically, a timing constraint is expressed in the form of a deadline and is represented as a priority to be used by schedulers. MVCC Algori...

متن کامل

Asynchronous Version Advancement in a Distributed Three-Version Database

We present an eecient protocol for multi-version concurrency control in distributed databases. The protocol creates no more than three versions of any data item, while guaranteeing that (1) update transactions never interfere with read-only transactions, (2) the version advancement mechanism is completely asynchronous with (both update and read-only) user transactions, and (3) read-only transac...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

عنوان ژورنال:
  • IEEE Trans. Knowl. Data Eng.

دوره 5  شماره 

صفحات  -

تاریخ انتشار 1993